The arrears report gives details of those loans whose loan repayments have been defaulted up to the selected reporting date.
How to view the arrears report
To get to this screen, go to Loans/Portfolio Reports/Analysis Reports/Arrears Report and a screen will appear looking like the one below:
Reporting Date: Enter the date up to which you want the arrears report to be generated, e.g., "31/01/2013" in the screen above.
Include Loans with dues on reporting date: When this option is selected, the arrears report will show only those loans that are in arrears up to the reporting date and those that are expected to be paid on that very date. In the example above, the reporting date is "31/01/2013"; therefore the arrears report will show all those loans that have not been repaid until this date.
Include all active Loans (not only arrears): When this option is selected, the arrears report will show all those loans that have outstanding balances for repayment (i.e. those with arrears as per the reporting date and those that were paid on time).
Print for loans in arrears of more than (Days): Enter a particular number of days for which you would like to see loans in arrears. This option is only available when you select "Include Loans with dues on reporting date" otherwise if the option "include all active Loans (not only arrears) is selected, it will not appear". This can be seen below;
Branch Code: Select a branch for which you want to generate a report. In the example above, we have checked "For all" option to have an arrears report for all branches.
Credit Officer: Select from the drop down box a particular credit officer whom you want to generate a report about, this may be to see the arrears report for clients who were handled by that officer selected. In the example, the "For all" option is checked.
Loan Fund: From the drop down box, select a particular Loan Fund that you want to generate a report about arrears, i.e. the loans whose repayments have been defaulted by clients that were got from a particular loan fund. The Loan Fund is set at menu System/Configuration/Funds. In the example, the "For all" option is checked.
Geographical Area: From the drop down box, you can select to generate an arrears report basing on the actual locations of the clients. For example Districts, County, Sub-County and Parish as specified in your settings under Menu Support Files/Geographical Area's. In the example in the first screen of this page, the "For all" option is selected in order to have an arrears report for clients from all geographical areas.
Loan Product: From the drop down box, select a loan Product that you want to generate a report about. The Loan product depends on what was set at Menu System/Configuration/Products. You may have Loan Products like School Fees Loans, Agricultural Loans etc. In the example above, the "For all" option is selected in order to have an arrears report for all Loan Products.
Business Sector: From the drop down box, select a business sector for which you want to generate an arrears report. This can be Agriculture, Industry, Services or any other depending on what you set at menu Support files/Business Sector. In the example above, the "For all" option is selected to have an arrears report for all business sectors in the selected period.
Grouping/Order: Select from the drop down box how the arrears report to be generated will be classified i.e. in the column title/heading. In the first screen on this page, client name is selected.
Report Format: Select from the drop down box the sequence in which the column titles in your arrears report will appear. In the first screen on this page, the first option is selected.
Client Category 1: From the drop down box, select a client based on the classification that you made at menu Support Files/Client Category 1. In the example, the "For all" option is checked. The same applies for Client Category 2 and client Category 3.
Loan Category 1: From the drop down box, select a classification of a loan that you made at Menu Support Files/Loan Category 1, it may have been a long term loan, short term loan etc. In the example, the "For all" option is checked. The same applies for Loan Category 2 and Loan Category 3.
Guarantee Items: Select a class of items that were used as security for loans from the drop down box. These are set at menu Support Files/ Loan Guarantee Items.
Select any other required additional options or use the default selections. For additional information on these options you can refer to Portfolio Report Formats.
Additional filtering options?: This option is used to get a particular field or specification that you want. It helps you to narrow down the search for information that you need. When you check this option and click OK, a pop up screen will appear. See below:
In the Additional filtering options pop up screen, select the required filter criteria from the drop down boxes, e.g., "LAMOUNT" (Loan Amount), Relational Operator, e.g., "=" (Equals sign) and the Value, e.g., "400,000".
Click the OK button if all the data entered is sufficient.
You will get another pop up information screen showing the filter for the arrears report that was selected. See below:
Click on the Yes command button if it is the right filter to generate the arrears report which will look similar to the following:
N.B: You can only check one option (either detail or summary) to produce an arrears report. It is not possible to check both options at the same time.
Click on the Close command button to exit the menu.